Skip to main content

Connect Salesforce to OPNBI using Data-Endpoints

Docusaurus Slash Introduction

  • By using this document user will know how to connect Salesforce to OPNBI using Data Endpoints.

  • Salesforce integration is the process of merging the data and functionality of Salesforce with another application to provide users with a single unified experience.

Objective

  • Connect Salesforce to OPNBI using Data-Endpoints.

Usecase

  • Salesforce allows users to fetch data from salesforce & integrate it with your application. For example; in this document, we will fetch the data from salesforce & integrate it with OPNBI.

Steps to Connect Salesforce to OPNBI

1. Salesforce

  • Salesforce provides the powerful source of the API which helps in developing and customizing your data.
  1. log in to your Salesforce developer edition.

  2. Follow the given links to know how to set up your salesforce login.

  1. User needs to Create the Connected App first.
Note
  • Follow this link to see how to create the connected app.
  1. While creating the Connected App fill below details:
  • Connected App Name: Opnbi
  • API Name: Opnbi (it will be filled automatically)
  • Contact Email: Your email address
  • Enable OAuth Settings: Check the checkbox
  • Set callback URL: https://na11.salesforce.com/ConnectTest/oauth/_callback
  • Selected OAuth Settings: Manage user data via APIs (API)

Docusaurus Slash Introduction

Docusaurus Slash Introduction

  1. Scroll down & click on the Save button. It will ask you for permission.

  2. Click on Continue button & your connected app is created.

    Docusaurus Slash Introduction

  3. User can copy & paste Consumer Key, Consumer Secret & Callback URL to a notepad for further use.

  • How to get Security Token?
  1. By following this link use can generate the Security Token.

  2. Reset your security token & save it in a notepad for further use.

Note
  • Click on this link to download the project files.

2. IntelliJ IDEA

  1. Download IntelliJ IDEA Community Edition & import the dowloaded project into it.

  2. Open java project file & new.properties file.

  3. User needs to fill the below details in the new.properties file:

  • url: https://'your domain name'.my.salesforce.com/services/data/v54.0/query/?
  • loginInstanceDomain: login.salesforce.com
  • apiVersion: " your salesforce api version "
  • userName: " your salesforce login username "
  • password: " your salesforce login password+security token "
  • consumerKey: " your consumer key "
  • consumerSecret: " your consumer secret "
  • grantType: password
  1. Save & Run your project file.

3. OPNBI

  • OPNBI is a Business Intelligence application for both personal and business use.
  1. Start your server & launch OPNBI.

  2. Go to hamburger menu Docusaurus Slash Introduction --> datasource.

  3. Click on Create from the bottom-most toolbar.

    Docusaurus Slash Introduction

  4. Find Data Endpoints from the search box:

    Docusaurus Slash Introduction

  5. Click on Data Endpoints & fill in the details as shown:

    Docusaurus Slash Introduction

  6. Click on the TEST CONNECTION button & one message is shown for Connection Successful.

    Docusaurus Slash Introduction

  7. Click on the OK & SAVE button & Go to the Datasource section in OPNBI.

  8. Select created Datasource & click on Create Dataset from the bottom-most toolbar.

  9. Give your dataset the name S_contacts.

  10. In query box write your query as shown. (User can get the query from the readme file available in the project zip file)

    Docusaurus Slash Introduction

  11. Click on the PREVIEW button & data of contacts is shown.

    Docusaurus Slash Introduction

  12. Click on SUBMIT button & your dataset is created.

  13. To know how to create dashboard using this dataset follow this link.